using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class web_pages_ajax_san_nguoi_tim_viec : System.Web.UI.Page
{
    public DataTable resdtt;
    Common comm = new Common();
    protected void Page_Load(object sender, EventArgs e)
    { 
        string ma_san = Request.QueryString["sid"];
        string sql = " select * from viecLamtrong_ho_so_tuyen_dung " +
                     " where ma_ho_so in (select ma_ho_so_tuyen_dung from SanGiaoDich_doanh_nghiep " +
                     " where ma_san ='"+ma_san+"') ";
       
           
            string ma_tp = Request.QueryString["tpid"];

            if(ma_tp.Length>0)
                sql += " and noi_lam_viec like '%"+ma_tp+"%'";
            string ma_nganh = Request.QueryString["nganhid"];
            if(ma_nganh.Length>0)
                sql += " and ma_ho_so in (select ma_ho_so from vieclamtrong_yeu_cau_chuyen_mon where ma_chuyen_mon = '"+ma_nganh+"' and kich_hoat = 1)";

       
        resdtt = comm.getDataTable(sql);
    }
}
